Software

Ask Software Development Questions and Get Answers ASAP

Ask a Computer Expert,
Get an Answer ASAP!

I am trying to connect to sql server from Dreamweaver 2017.

Customer Question
When I used the connection...
I am trying to connect to sql server from Dreamweaver 2017. When I used the connection string, it shows the data source name was invalid. Can anybody help with this issue?
Submitted: 6 months ago.Category: Software
Show More
Show Less
Ask Your Own Software Question
Answered in 4 hours by:
12/28/2017
Software technician: Russell H., Computer Support Specialist replied 6 months ago
Russell H.
Russell H., Computer Support Specialist
Category: Software
Satisfied Customers: 12,791
Experience: Proud to have been getting computer technicalities into working order since 1988.
Verified

Hi, thank you for contacting JustAnswer.com. My name is***** will do my best to provide the right answer to your computer question.

The cause of that error - which is somewhat general and not specifically indicative - could be many things.

1. make sure you are connected to the data source/network where the data source is, and the internet too of course.

2. then make sure you are authorized for access to the data source/network also e.g. logged in, that sort of thing.

3. then it's a matter of carefully checking syntax and procedure also, esp. if this code has never connected before.

Tell me some details in Reply - is it PHP, or some other programming system, that's involved? - and so forth, and I will help and advise further, if I can know some specifics about the problem.

If this answers your question, please rate my answer. A five-star rating would be appreciated!

If you need more info, or have any comments, use Reply To Expert to respond.

Thanks.

Ask Your Own Software Question
Customer reply replied 6 months ago
I am using php. I used dmxzone extensions, but they did not work. At first it said it could not find the driver. I installed the pdo and added the extensions, but still could not connect. Thank you in advance trying to help!
Software technician: Russell H., Computer Support Specialist replied 6 months ago

Well, I admit I'm not very good at PHP code, myself, but another Expert here should be able to get into the details of the problem to some purpose for you.

Before I go - unless I see some way I myself can help you - please tell me, or confirm my impression, that this is not a case of code that worked before and now doesn't work, but rather of code that needs to be gotten working for the first time - ?

Ask Your Own Software Question
Customer reply replied 6 months ago
That is correct I'm trying any way I can to connect to sql server
Customer reply replied 6 months ago
It could very well be something else besides code. I do not know what the problem is :)
Software technician: Russell H., Computer Support Specialist replied 6 months ago

Well... what SQL server are you trying to connect to, vaguely speaking?

And, have you installed MyODBC or ODBCConnection or similar driver for ODBC access to SQL databases ? that can help.

Ask Your Own Software Question
Customer reply replied 6 months ago
Odbc driver is there. Sql server
Software technician: Russell H., Computer Support Specialist replied 6 months ago

OK... at this point I think that, having covered the basics, I should step out of this case in favor of a more PHP-expert Expert. I have Opted Out, opening the case to other - esp. PHP - Experts in this category. Thank you for your patience. If and when another Expert picks up the case, you should receive a notification email.

Ask Your Own Software Question
Customer reply replied 6 months ago
Thank you though
Software technician: Russell H., Computer Support Specialist replied 6 months ago

You're welcome. I have - to repeat - Opted Out, opening the case to other Experts in this category.

Ask Your Own Software Question
Software technician: Pete, Computer Expert replied 6 months ago
Pete
Pete, Computer Expert
Category: Software
Satisfied Customers: 20,387
Experience: CISCO certified computer and networking expert
Verified

Hello, I see the previous expert has left the conversation.

My name is***** will try my best to help you with your question.

See the following guide and let me know which step you get stuck at:

https://helpx.adobe.com/dreamweaver/kb/connect-mysql-database-dreamweaver.html

Ask Your Own Software Question
Customer reply replied 6 months ago
I'm confused. I cAn connect with vbscript. How do I create a form with that and send it to the sql server database?
Software technician: Pete, Computer Expert replied 6 months ago

To establish a database connection with VBScript, see the following guide:

https://www.youtube.com/watch?v=S4pIpMZyTJQ

Ask Your Own Software Question
Customer reply replied 6 months ago
I tried the dmxzone extensions. They didn't work. I am not trying to connect to MySQL; I'm trying to connect to sql server
Software technician: Pete, Computer Expert replied 6 months ago

What errors are you getting?

Ask Your Own Software Question
Customer reply replied 6 months ago
when I use windows authentication, I get the following:
Call to undefined function odbc_connect() in c:\xampp\htdocs\test\windowsconnectWhen I use Sql Server connection, I get the following:
syntax error, unexpected 'if (T_IF) in c:\xampp\htdos\test\connection.phpDo I need a different password?
Customer reply replied 6 months ago
How would I know if the driver is outdated or corrupt?
Software technician: Pete, Computer Expert replied 6 months ago

You can check the drivers in Device Manager.

Ask Your Own Software Question
Customer reply replied 6 months ago
I checked under disk drive. Showed it was up to date. Is it my connection code?
Customer reply replied 6 months ago
How do I know if my dsn is correct?
Software technician: Pete, Computer Expert replied 6 months ago
  1. In the Windows Control Panel, double-click Administrative Tools.

  2. Then in the Administrative Tools dialog box, double-click Data Sources (ODBC).

    The ODBC Data Source Administrator dialog box appears.

  3. Click User DSN, System DSN, or File DSN to check the relevant DSN.

Ask Your Own Software Question
Customer reply replied 6 months ago
I have the ODBC driver 13 for SQL server and SQL Server Native Client 11.0
Thanks for trying to help, btw
Customer reply replied 6 months ago
Ok maybe it's not the updated version. Where do I get the 64 bit odbc? I tried but it showed it wasn't compatible. I'm running windows 7
Software technician: Pete, Computer Expert replied 6 months ago

Are you running a 64 bit system?

Ask Your Own Software Question
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a software technicianLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask Pete Your Own Question
Pete
Pete
Pete, Computer Expert
Category: Software
Satisfied Customers: 20,387
20,387 Satisfied Customers
Experience: CISCO certified computer and networking expert

Pete is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

Jess M.

Jess M.

Computer Support Specialist

802 satisfied customers

Computer Software Support specialist for more that 10 years

Kamil Anwar

Kamil Anwar

Software Specialist

543 satisfied customers

8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.

Chris L.

Chris L.

Support Specialist

526 satisfied customers

Certified Software expert with over 10 years experience.

Jins M. N.

Jins M. N.

Computer Hardware Engineer

523 satisfied customers

12+ years experience. Expert in installing and problem fixing of softwares.

IT Miro

IT Miro

Computer Scientist

513 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

Steve Herrod

Steve Herrod

Computer Support Specialist

220 satisfied customers

Familiar with a wide variety of software and experienced in user training/support

Byron

Byron

Computer Support Specialist

205 satisfied customers

12 years in operations at a large law firm supporting both retail and specialty applications.

< Previous | Next >

Related Software Questions
I am a layman trying to load sql 2017. Training for
training for datascience anway keep getting an error message … read more
Michael Rademacher
Michael Rademacher
MBA
13 satisfied customers
I have a question that is related to Microsoft IIS and
I have a question that is related to Microsoft IIS and Microsoft SQL Server MDS. Not sure if this is the currect forum to go to. … read more
David L.
David L.
Bachelor\u0027s Degree
6 satisfied customers
I cannot connect my Dreamweaver 2018 to sql server. It's for
Hello. I cannot connect my Dreamweaver 2018 to sql server … read more
Pete
Pete
Computer Expert
Bachelor's Degree
20,387 satisfied customers
I seem to be having a problem with a new installation of
I seem to be having a problem with a new installation of Adobe Dreamweaver 2017 CC. Tiling is not working. Can someone please help?… read more
Pete
Pete
Computer Expert
Bachelor's Degree
20,387 satisfied customers
VB .NET and SQL Server. Need VB code to insert data from a
VB .NET and SQL Server. Need VB code to insert data from a comma delimited text file into SQL table. Then run a query against the table. Rather than having the query hard coded in the VB code I would … read more
George Sibiya
George Sibiya
PhD
309 satisfied customers
I downloaded Adobe Photoshop 2017 and I get the error
I downloaded Adobe Photoshop 2017 and I get the error message "Adobe Photoshop has stopped working. It states it is a problem with Windows (10) and it is closing. I also had the same problem with Drea… read more
Dustin
Dustin
Support Technician
2,887 satisfied customers
I'm trying to migrate data into MYSQL from MS SQL Server 2008.
I'm trying to migrate data into MYSQL from MS SQL Server 2008. I attempted to use the migration tool in the MS SQL workbench which opens a Migration tool wizard. I managed to get to he second screen w… read more
technicalcat
technicalcat
Computer Science
840 satisfied customers
What is a good mysql editor? I want to be able to edit
What is a good mysql editor? I want to be able to edit the tables and have the editor be smart to show a dropdown for the foreign key relationship.… read more
ehabtutor
ehabtutor
C.E.O
Bachelor\u0027s Degree
12 satisfied customers
My clients programming guy moved its website to a new server.
My client's programming guy moved its website to a new server. I use Dreamweaver CS3. Can't connect, though I have all the relevant info (username, password, hosting server, SFTP status). Online searc… read more
Jins M. N.
Jins M. N.
Computer Hardware Engineer
Diplom
523 satisfied customers
We are seeking to install SQL Express 2005 on a 64 bit windows
We are seeking to install SQL Express 2005 on a 64 bit windows 7 system. We are receiving an error: SQL server setup cannot write system databases to c:/programfiles/microsoftsqlserver/mssql.1 because… read more
Jins M. N.
Jins M. N.
Computer Hardware Engineer
Diplom
523 satisfied customers
I am getting an FTP error. I got with my server and the issue
I am getting an FTP error. I got with my server and the issue seems to lie somewhere in Dreamweaver as we can get into things by Navigator… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,464 satisfied customers
I wanna download SQL Server 2008 For windows 8 - 64 bit , I
I wanna download SQL Server 2008 For windows 8 - 64 bit , I need full package , from where can I download it ? I went to microsoft.com but it's complicated !… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,464 satisfied customers
This is about a problem with MS-SQL server 2005 Express. We
This is about a problem with MS-SQL server 2005 Express. We originally set up SQL express for our accounting system operating on a single computer, which it did fine. Now, we want to use the program o… read more
Brandon M.
Brandon M.
System Administrator
Vocational, Technical or Trade Scho
2,143 satisfied customers
Often having problem when restarting Windows Server 2008R2
Often having problem when restarting Windows Server 2008R2 to connect mysql database on localhost. Can you explain what is problem?… read more
John Iacono
John Iacono
Managing network engineer
Bachelor
265 satisfied customers
I need an Oracle PL/SQL expert please for prompt assistance.
I need an Oracle PL/SQL expert please for prompt assistance. Please do not look at low price, I will compensate with great bonus. Need help ASAP Thanks… read more
Steven Caliendo
Steven Caliendo
Vocational, Technical or Trade Scho
99 satisfied customers
Im installing 3rd party software on a new desktop. HP running
I'm installing 3rd party software on a new desktop. HP running i7 processor, windows 7 ultimate. I get a message when opening the software (Planit Cabinetvision rlse 7.1) indicating sql connection fai… read more
David L.
David L.
Bachelor\u0027s Degree
6 satisfied customers
$ 50 bonus. MS SQL is consuming 24 gigs of memory 30 minutes
$ 50 bonus. MS SQL is consuming 24 gigs of memory 30 minutes after re-boot. I have a Dell T610 server running Windows 2008 R2 server running IIS and an MS SQL application and Quick books. Over the las… read more
Mark
Mark
High School or GED
640 satisfied customers
I want to migrate my database to another server here is my
I want to migrate my database to another server here is my steps: detach database copy the mdf file to the new server (without copy the ldf file) create a new db in the new server with the same name o… read more
FDM Consulting
FDM Consulting
Senior Solution Architect
Master\u0027s Degree
29 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x