Software

Ask Software Development Questions and Get Answers ASAp

Ask a Computer Expert,
Get an Answer ASAP!

Software

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

What errors are you getting?

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

You can check the drivers in Device Manager.

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

Are you running a 64 bit system?

Ask Your Own Software Question
Ask Pete Your Own Question
Pete
Pete
Pete, Computer Expert
Category: Software
Satisfied Customers: 19,132
19,132 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 purchased the Adobe yearly Adobe Export PDF and I am
I purchased the Adobe yearly Adobe Export PDF and I am trying to use it and it keeps directing me to pay again but I already paid for it for the whole year. … read more
Alfredo Borgaro
Alfredo Borgaro
Country Manager Mexico & Panama
Master\u0027s Degree
5 satisfied customers
I am making some changes on an excel workbook. It is a
I am making some changes on an excel workbook. It is a workbook that contains an identical sheet for each month as well as two other sheets for yearly tallies. Is there some way to propagate changes t… read more
The-PC-Guy
The-PC-Guy
Bachelor\u0027s Degree
629 satisfied customers
I riceve 6 code numbers thy ask for 4. I need help for
I riceve 6 code numbers thy ask for 4 JA: What device or product does this involve? Customer: I need help for Skype JA: When did you last update Skype? Customer: monts go JA: What have you tried so fa… read more
Josh
Josh
It Support Specialist
Associate Degree
5,145 satisfied customers
The last couple Windows 10 updates got the computer to not
the last couple Windows 10 updates got the computer to not boot, so rolled back to a restore point. still the drivers were goofed up on USB ports and the troubleshooters had me reboot which again trie… read more
Kris R
Kris R
IT Manager
Computing
3,067 satisfied customers
I dont any money to pay i have the $5.00 n thats all. Acer.
i dont any money to pay i have the $5.00 n thats all … read more
Josh
Josh
It Support Specialist
Associate Degree
5,145 satisfied customers
I am writing a letter to a friend in Spain ,after I finished
I am writing a letter to a friend in Spain ,after I finished can I send it on skype ,if so and how I do it ?… read more
Mr.Med
Mr.Med
975 satisfied customers
I need help installing AOL malwarebytes. I have been an AOL
I need help installing AOL malwarebytes. I have been an AOL customer for many years. … read more
Byron
Byron
Computer Support Specialist
Bachelor's Degree
164 satisfied customers
Our business hours are not posted correctly when patients
Our business hours are not posted correctly when patients google Dentist in our area. … read more
Samuel Kresslein
Samuel Kresslein
Associate\u0027s Degree
225 satisfied customers
My 2017 Home and Business Disc won't load into my Toshiba
My 2017 Home and Business Disc won't load into my Toshiba PC? Has never happened before. … read more
UranIT
UranIT
IT Consultant, Network and System Admin
Associate Degree
662 satisfied customers
My step son axcessed my account and changed his user name on
my step son axcessed my account and changed his user name on utube … read more
Josh
Josh
It Support Specialist
Associate Degree
5,145 satisfied customers
Hope ur well, I'm trying to find out my driver status, its
hey pearl, hope ur well , I'm trying to find out my driver status, its been 10 days I believe … read more
Josh
Josh
It Support Specialist
Associate Degree
5,145 satisfied customers
My asus has a stop code critical process died. Asus. Q504u.
My asus has a stop code critical process died JA: What device or product does this involve? Customer: Asus JA: What Asus model do you have? And the Operating System (OS)? Customer: Q504u JA: How long … read more
Dan
Dan
IT/Broadcast Engineer
Bachelor\u0027s Degree
508 satisfied customers
It keeps shutting down, Blue Screen now it says Event
it keeps shutting down, Blue Screen now it says Event Tracking Fatal error … read more
David L.
David L.
Bachelor\u0027s Degree
6 satisfied customers
I purchased Adobe 18 several months ago, but it is not on my
I purchased Adobe 18 several months ago, but it is not on my PC. Can't remember if it was downloaded or not. And, sorry, I don't have purchase info. … read more
UranIT
UranIT
IT Consultant, Network and System Admin
Associate Degree
662 satisfied customers
I have adobe contribute 6.5 and use to support website - PVP
I have adobe contribute 6.5 and use to support website - PVP Watch.com. … read more
Kris R
Kris R
IT Manager
Computing
3,067 satisfied customers
I got on facebook and got on a dating app loss every thing i
i got on facebook and got on a dating app loss every thing i want my acc back … read more
Josh
Josh
It Support Specialist
Associate Degree
5,145 satisfied customers
What's the name of a program that helps you organize your
What's the name of a program that helps you organize your business spending and task by date, employee, etc, and where can I get it?… read more
caraleneK
caraleneK
Service Manager
1,676 satisfied customers
I have an SD card with several PDF documents on it. I'm
I have an SD card with several PDF documents on it. I'm trying to see if there is any way to send all of the documents to print all at once rather than opening each one to print separately. If so it w… read more
Cris
Cris
58 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