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: 3 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 3 months ago
Russell H.
Russell H., Computer Support Specialist
Category: Software
Satisfied Customers: 12,220
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 3 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 3 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 3 months ago
That is correct I'm trying any way I can to connect to sql server
Customer reply replied 3 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 3 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 3 months ago
Odbc driver is there. Sql server
Software technician: Russell H., Computer Support Specialist replied 3 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 3 months ago
Thank you though
Software technician: Russell H., Computer Support Specialist replied 3 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 3 months ago
Pete
Pete, Computer Expert
Category: Software
Satisfied Customers: 19,721
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 3 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 3 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 3 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 3 months ago

What errors are you getting?

Ask Your Own Software Question
Customer reply replied 3 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 3 months ago
How would I know if the driver is outdated or corrupt?
Software technician: Pete, Computer Expert replied 3 months ago

You can check the drivers in Device Manager.

Ask Your Own Software Question
Customer reply replied 3 months ago
I checked under disk drive. Showed it was up to date. Is it my connection code?
Customer reply replied 3 months ago
How do I know if my dsn is correct?
Software technician: Pete, Computer Expert replied 3 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 3 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 3 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 3 months ago

Are you running a 64 bit system?

Ask Your Own Software Question
Was this answer helpful?
Ask Pete Your Own Question
Pete
Pete
Pete, Computer Expert
Category: Software
Satisfied Customers: 19,721
19,721 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

670 satisfied customers

Computer Software Support specialist for more that 10 years

Chris L.

Chris L.

Support Specialist

505 satisfied customers

Certified Software expert with over 10 years experience.

IT Miro

IT Miro

Computer Scientist

497 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

Jins M. N.

Jins M. N.

Computer Hardware Engineer

463 satisfied customers

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

Kamil Anwar

Kamil Anwar

Software Specialist

456 satisfied customers

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

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

164 satisfied customers

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

< Previous | Next >

Related Software Questions
I had my Windows 10 reinstalled by a Micro Center technician
I had my Windows 10 reinstalled by a Micro Center technician after an issue. I cannot get Windows to recognize the HP LaserJet 1200 via USB as it had for years. I even verified that there is no cable … read more
Cody
Cody
Computer Science
2,152 satisfied customers
App was updating 3days ago and has never finished how do I
App was updating 3days ago and has never finished how do I fix it? … read more
Moses C
Moses C
Bsc
561 satisfied customers
Seems that after having Norton coverage for several years,
Seems that after having Norton coverage for several years, my coverage has been dropped or I have some kind of problem with my pc.....can you research this ??? I am Jxxxxx X Txxxxx, phone is xxxxxxxxx… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,395 satisfied customers
My insprion one was stolen. What can be done. Windows 8.1.
Just found out this morning...I believe a room mate took it … read more
Michael Rademacher
Michael Rademacher
MBA
4 satisfied customers
Had virus on computer. trying to sign back into login. I
Had virus on computer. trying to sign back into login. I have been a member for years. Your site tells me that the email address is already taken. Of course it is already taken. It is taken by ME. The… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,395 satisfied customers
Im trying to open Access on microsoft 365 and Access isnt
im trying to open Access on microsoft 365 and Access isnt even an option that appears why is this … read more
Cody
Cody
Computer Science
2,152 satisfied customers
From pogo poppit bingo this weeks badge will not play a
from pogo poppit bingo this weeks badge will not play a whole game … read more
Karthik
Karthik
Senior Engineer
Bachelor of Engineering
91 satisfied customers
I have a question about Outlook 2010. I deleted my Yahoo
I have a question about Outlook 2010.I deleted my Yahoo POP3 account and established a Yahoo IMAP account also within Outlook 2010. All emails in the Inbox are present. I cannot get the folders from t… read more
Jason Jones
Jason Jones
AAS Information Technology
6,322 satisfied customers
I wanted to stream movies on prime I put my email address
I wanted to stream movies on prime I put my email address and my password ***** it keeps saying unexpected error … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,395 satisfied customers
Since a recent Win10 update, explorer.exe won't release file
Since a recent Win10 update, explorer.exe won't release file handles for some files and folders it has recently visited. Even closing File Explorer doesn't help. LockHunter fails to close the handles,… read more
Michael Rademacher
Michael Rademacher
MBA
4 satisfied customers
Having a big problem recovering my password for a facebook
having a big problem recovering my password ***** a facebook account … read more
Michael Rademacher
Michael Rademacher
MBA
4 satisfied customers
Have been trying to verify a new bank account as I had to
Have been trying to verify a new bank account as I had to close the last due to hacking. There seems to be a mix up re my password. Can you help me reset my password ***** verify my new bank account s… read more
Jeevan DSouza
Jeevan DSouza
Professor
PhD
3 satisfied customers
I have Windows 10 latest version updates. I also have two
Hello.I have Windows 10 latest version updates.I also have two Philips 4k Monitors.I have just updated a piece of software with the software updater. Before updating I dragged the updater software to … read more
Pete
Pete
Computer Expert
19,721 satisfied customers
I cant get bk n yo my Microsoft acc. Not sure. A time its
A long time its not my pc its my account i cant even get n my cataloge either … read more
Moses C
Moses C
Bsc
561 satisfied customers
Can Adobe Recommend a DVD/BluRay Authoring program
Can Adobe Recommend a DVD/BluRay Authoring program comparable to Encore? … read more
hongkongpom
hongkongpom
Computer Desktop Support
Associate Degree
286 satisfied customers
I have McAfee but I have a Random Attack on my PC. Advance
I have McAfee but I have a Random Attack on my PC JA: Which McAfee product do you have? Customer: Advance on both Pc and Phone JA: What have you tried so far with your McAfee software? Customer: so ho… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,395 satisfied customers
My iMac is telling me I have a virus
My iMac is telling me I have a virus (Tapsnake;CronDNS;Dubfischicv) and that I should download Advanced MacCleaner immediately. Should I do this. … read more
Ricky Kresslein
Ricky Kresslein
Bachelor\u0027s Degree
780 satisfied customers
I purchased the McAfee protection a short time ago, I've
Hi, My name is***** I purchased the McAfee protection a short time ago, I've misplaced my information, and need to add another computer. I think I purchased up to five devices. … read more
arsufi2002
arsufi2002
Bachelor's Degree
322 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